700 |
Is it possible to colour a particular column for specified values
axGantt1.BeginUpdate(); EXGANTTLib.ConditionalFormat var_ConditionalFormat = axGantt1.ConditionalFormats.Add("int(%1) in (3,4,5)",null); var_ConditionalFormat.BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0)); var_ConditionalFormat.ApplyTo = (EXGANTTLib.FormatApplyToEnum)0x1; axGantt1.MarkSearchColumn = false; EXGANTTLib.Columns var_Columns = axGantt1.Columns; var_Columns.Add("Column 1"); var_Columns.Add("Column 2"); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.set_CellCaption(var_Items.AddItem(0),1,1); var_Items.set_CellCaption(var_Items.AddItem(2),1,3); var_Items.set_CellCaption(var_Items.AddItem(4),1,5); axGantt1.EndUpdate(); |
699 |
Is it possible to colour a particular column
axGantt1.BeginUpdate(); axGantt1.MarkSearchColumn = false; EXGANTTLib.Columns var_Columns = axGantt1.Columns; var_Columns.Add("Column 1"); (var_Columns.Add("Column 2") as EXGANTTLib.Column).set_Def(EXGANTTLib.DefColumnEnum.exCellBackColor,255); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.set_CellCaption(var_Items.AddItem(0),1,1); var_Items.set_CellCaption(var_Items.AddItem(2),1,3); var_Items.set_CellCaption(var_Items.AddItem(4),1,5); axGantt1.EndUpdate(); |
698 |
How do i get all the children items that are under a certain parent Item handle
axGantt1.BeginUpdate(); axGantt1.LinesAtRoot = EXGANTTLib.LinesAtRootEnum.exLinesAtRoot; axGantt1.Columns.Add("P"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_ExpandItem(h,true); EXGANTTLib.Items var_Items1 = axGantt1.Items; int hChild = var_Items1.get_ItemChild(var_Items1.FirstVisibleItem); System.Diagnostics.Debug.Print( var_Items1.get_CellCaption(hChild,0).ToString() ); System.Diagnostics.Debug.Print( var_Items1.get_CellCaption(var_Items1.get_NextSiblingItem(hChild),0).ToString() ); axGantt1.EndUpdate(); |
697 |
How can I change the predefined labels being displayed in the chart's header so it shows the data in short format with no literals
axGantt1.BeginUpdate(); EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.set_PaneWidth(false,0); var_Chart.LevelCount = 3; var_Chart.OverviewVisible = EXGANTTLib.OverviewVisibleEnum.exOverviewShowAll; var_Chart.AllowOverviewZoom = EXGANTTLib.OverviewZoomEnum.exAlwaysZoom; var_Chart.set_Label(EXGANTTLib.UnitEnum.exYear,"<%yy%><|><%yyyy%>"); var_Chart.set_Label(EXGANTTLib.UnitEnum.exHalfYear,""); var_Chart.set_Label(EXGANTTLib.UnitEnum.exQuarterYear,""); var_Chart.set_Label(EXGANTTLib.UnitEnum.exMonth,"<|><%m%><|><%m%>/<%yy%><|><%m%>/<%yyyy%>"); var_Chart.set_Label(EXGANTTLib.UnitEnum.exThirdMonth,""); var_Chart.set_Label(EXGANTTLib.UnitEnum.exWeek,"<|><%ww%><|><%m%>/<%d%>/<%yy%><r><%ww%><|><%m%>/<%d%>/<%yyyy%><r><%ww%><||><||>256"); var_Chart.set_Label(EXGANTTLib.UnitEnum.exDay,"<|><%d%><|><%m%>/<%d%>/<%yy%><|><%m%>/<%d%>/<%yyyy%><||><||>4096"); var_Chart.set_Label(EXGANTTLib.UnitEnum.exHour,"<|><%hh%><|><%m%>/<%d%>/<%yy%> <%h%> <%AM/PM%><|><%m%>/<%d%>/<%yyyy%> <%h%> <%AM/PM%><||><||>65536"); var_Chart.set_Label(EXGANTTLib.UnitEnum.exMinute,"<|><%nn%><|><%h%>:<%nn% <%AM/PM%>><|><%m%>/<%d%>/<%yy%> <%h%>:<%nn%> <%AM/PM%><|><%m%>/<%d%>/<%yyyy%> <%h%>:<%nn%> <%AM/PM%>"); var_Chart.set_Label(EXGANTTLib.UnitEnum.exSecond,"<|><%ss%><|><%nn%>:<%ss%><|><%h%>:<%nn%>:<%ss%> <%AM/PM%><|><%m%>/<%d%>/<%yy%> <%h%>:<%nn%>:<%ss%> <%AM/PM%><|><%m%>/<%d%>/<%yy" + "yy%> <%h%>:<%nn%>:<%ss%> <%AM/PM%>"); var_Chart.set_LabelToolTip(EXGANTTLib.UnitEnum.exYear,"<%yyyy%>"); var_Chart.set_LabelToolTip(EXGANTTLib.UnitEnum.exHalfYear,""); var_Chart.set_LabelToolTip(EXGANTTLib.UnitEnum.exQuarterYear,""); var_Chart.set_LabelToolTip(EXGANTTLib.UnitEnum.exMonth,"<%m%>/<%yyyy%>"); var_Chart.set_LabelToolTip(EXGANTTLib.UnitEnum.exThirdMonth,""); var_Chart.set_LabelToolTip(EXGANTTLib.UnitEnum.exWeek,"<%m%>/<%d%>/<%yyyy%> <%ww%>"); var_Chart.set_LabelToolTip(EXGANTTLib.UnitEnum.exDay,"<%m%>/<%d%>/<%yyyy%>"); var_Chart.set_LabelToolTip(EXGANTTLib.UnitEnum.exHour,"<%m%>/<%d%>/<%yyyy%> <%h%> <%AM/PM%>"); var_Chart.set_LabelToolTip(EXGANTTLib.UnitEnum.exMinute,"<%m%>/<%d%>/<%yyyy%> <%h%>:<%nn%> <%AM/PM%>"); var_Chart.set_LabelToolTip(EXGANTTLib.UnitEnum.exSecond,"<%m%>/<%d%>/<%yyyy%> <%h%>:<%nn%>:<%ss%> <%AM/PM%>"); var_Chart.UnitScale = EXGANTTLib.UnitEnum.exDay; axGantt1.EndUpdate(); |
696 |
How can I get the caption of focused item
// SelectionChanged event - Fired after a new item has been selected. private void axGantt1_SelectionChanged(object sender, EventArgs e) { EXGANTTLib.Items var_Items = axGantt1.Items; System.Diagnostics.Debug.Print( "Handle" ); System.Diagnostics.Debug.Print( var_Items.FocusItem.ToString() ); System.Diagnostics.Debug.Print( "Caption" ); System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.FocusItem,0).ToString() ); } //this.axGantt1.SelectionChanged += new EventHandler(this.axGantt1_SelectionChanged); axGantt1.BeginUpdate(); axGantt1.LinesAtRoot = EXGANTTLib.LinesAtRootEnum.exLinesAtRoot; axGantt1.Columns.Add("Items"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("R1"); var_Items.InsertItem(h,null,"Cell 1.1"); var_Items.InsertItem(h,null,"Cell 1.2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("R2"); var_Items.InsertItem(h,null,"Cell 2.1"); var_Items.InsertItem(h,null,"Cell 2.2"); var_Items.set_ExpandItem(h,true); axGantt1.EndUpdate(); |
695 |
How can I get the caption of selected item
// SelectionChanged event - Fired after a new item has been selected. private void axGantt1_SelectionChanged(object sender, EventArgs e) { EXGANTTLib.Items var_Items = axGantt1.Items; System.Diagnostics.Debug.Print( "Handle" ); System.Diagnostics.Debug.Print( var_Items.get_SelectedItem(0).ToString() ); System.Diagnostics.Debug.Print( "Caption" ); System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.get_SelectedItem(0),0).ToString() ); } //this.axGantt1.SelectionChanged += new EventHandler(this.axGantt1_SelectionChanged); axGantt1.BeginUpdate(); axGantt1.LinesAtRoot = EXGANTTLib.LinesAtRootEnum.exLinesAtRoot; axGantt1.Columns.Add("Items"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("R1"); var_Items.InsertItem(h,null,"Cell 1.1"); var_Items.InsertItem(h,null,"Cell 1.2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("R2"); var_Items.InsertItem(h,null,"Cell 2.1"); var_Items.InsertItem(h,null,"Cell 2.2"); var_Items.set_ExpandItem(h,true); axGantt1.EndUpdate(); |
694 |
How can I highligth the item from the cursor as it moves
// MouseMove event - Occurs when the user moves the mouse. private void axGantt1_MouseMoveEvent(object sender, AxEXGANTTLib._IGanttEvents_MouseMoveEvent e) { axGantt1.BeginUpdate(); int h = axGantt1.get_ItemFromPoint(-1,-1,c,hit); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.ClearItemBackColor(axGantt1.get_Background((EXGANTTLib.BackgroundPartEnum)0x200 | EXGANTTLib.BackgroundPartEnum.exHSRight | EXGANTTLib.BackgroundPartEnum.exListOLEDropPosition)); var_Items.set_ItemBackColor(h,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,250,240))); axGantt1.set_Background((EXGANTTLib.BackgroundPartEnum)0x200 | EXGANTTLib.BackgroundPartEnum.exHSRight | EXGANTTLib.BackgroundPartEnum.exListOLEDropPosition,h); axGantt1.EndUpdate(); } //this.axGantt1.MouseMoveEvent += new AxEXGANTTLib._IGanttEvents_MouseMoveEventHandler(this.axGantt1_MouseMoveEvent); axGantt1.BeginUpdate(); axGantt1.LinesAtRoot = EXGANTTLib.LinesAtRootEnum.exLinesAtRoot; axGantt1.DrawGridLines = EXGANTTLib.GridLinesEnum.exHLines; axGantt1.SelBackColor = Color.FromArgb(240,250,240); axGantt1.SelForeColor = Color.FromArgb(0,0,0); axGantt1.ShowFocusRect = false; EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.SelBackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(240,250,240)); axGantt1.Columns.Add("Items"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("R1"); var_Items.InsertItem(h,null,"Cell 1.1"); var_Items.InsertItem(h,null,"Cell 1.2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("R2"); var_Items.InsertItem(h,null,"Cell 2.1"); var_Items.InsertItem(h,null,"Cell 2.2"); var_Items.set_ExpandItem(h,true); axGantt1.EndUpdate(); |
693 |
How can I get the item from the cursor
// MouseMove event - Occurs when the user moves the mouse. private void axGantt1_MouseMoveEvent(object sender, AxEXGANTTLib._IGanttEvents_MouseMoveEvent e) { int h = axGantt1.get_ItemFromPoint(-1,-1,c,hit); System.Diagnostics.Debug.Print( "Handle" ); System.Diagnostics.Debug.Print( h.ToString() ); System.Diagnostics.Debug.Print( "Index" ); System.Diagnostics.Debug.Print( axGantt1.Items.get_ItemToIndex(h).ToString() ); } //this.axGantt1.MouseMoveEvent += new AxEXGANTTLib._IGanttEvents_MouseMoveEventHandler(this.axGantt1_MouseMoveEvent); axGantt1.BeginUpdate(); axGantt1.LinesAtRoot = EXGANTTLib.LinesAtRootEnum.exLinesAtRoot; axGantt1.DrawGridLines = EXGANTTLib.GridLinesEnum.exHLines; axGantt1.Columns.Add("Items"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("R1"); var_Items.InsertItem(h,null,"Cell 1.1"); var_Items.InsertItem(h,null,"Cell 1.2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("R2"); var_Items.InsertItem(h,null,"Cell 2.1"); var_Items.InsertItem(h,null,"Cell 2.2"); var_Items.set_ExpandItem(h,true); axGantt1.EndUpdate(); |
692 |
How can I get the column from the cursor, not only in the header
// MouseMove event - Occurs when the user moves the mouse. private void axGantt1_MouseMoveEvent(object sender, AxEXGANTTLib._IGanttEvents_MouseMoveEvent e) { System.Diagnostics.Debug.Print( axGantt1.get_ColumnFromPoint(-1,0).ToString() ); } //this.axGantt1.MouseMoveEvent += new AxEXGANTTLib._IGanttEvents_MouseMoveEventHandler(this.axGantt1_MouseMoveEvent); axGantt1.BeginUpdate(); axGantt1.LinesAtRoot = EXGANTTLib.LinesAtRootEnum.exLinesAtRoot; axGantt1.Columns.Add("P1"); axGantt1.Columns.Add("P2"); axGantt1.DrawGridLines = EXGANTTLib.GridLinesEnum.exAllLines; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("R1"); var_Items.set_CellCaption(h,1,"R2"); var_Items.set_CellCaption(var_Items.InsertItem(h,null,"Cell 1.1"),1,"Cell 1.2"); var_Items.set_CellCaption(var_Items.InsertItem(h,null,"Cell 2.1"),1,"Cell 2.2"); var_Items.set_ExpandItem(h,true); axGantt1.EndUpdate(); |
691 |
How can I get the column from the cursor
// MouseMove event - Occurs when the user moves the mouse. private void axGantt1_MouseMoveEvent(object sender, AxEXGANTTLib._IGanttEvents_MouseMoveEvent e) { System.Diagnostics.Debug.Print( axGantt1.get_ColumnFromPoint(-1,-1).ToString() ); } //this.axGantt1.MouseMoveEvent += new AxEXGANTTLib._IGanttEvents_MouseMoveEventHandler(this.axGantt1_MouseMoveEvent); axGantt1.BeginUpdate(); axGantt1.LinesAtRoot = EXGANTTLib.LinesAtRootEnum.exLinesAtRoot; axGantt1.DrawGridLines = EXGANTTLib.GridLinesEnum.exAllLines; axGantt1.Columns.Add("P1"); axGantt1.Columns.Add("P2"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("R1"); var_Items.set_CellCaption(h,1,"R2"); var_Items.set_CellCaption(var_Items.InsertItem(h,null,"Cell 1.1"),1,"Cell 1.2"); var_Items.set_CellCaption(var_Items.InsertItem(h,null,"Cell 2.1"),1,"Cell 2.2"); var_Items.set_ExpandItem(h,true); axGantt1.EndUpdate(); |
690 |
How can I get the cell's caption from the cursor
// MouseMove event - Occurs when the user moves the mouse. private void axGantt1_MouseMoveEvent(object sender, AxEXGANTTLib._IGanttEvents_MouseMoveEvent e) { int h = axGantt1.get_ItemFromPoint(-1,-1,c,hit); System.Diagnostics.Debug.Print( axGantt1.Items.get_CellCaption(h,c).ToString() ); } //this.axGantt1.MouseMoveEvent += new AxEXGANTTLib._IGanttEvents_MouseMoveEventHandler(this.axGantt1_MouseMoveEvent); axGantt1.BeginUpdate(); axGantt1.LinesAtRoot = EXGANTTLib.LinesAtRootEnum.exLinesAtRoot; axGantt1.Columns.Add("Items"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("R1"); var_Items.InsertItem(h,null,"Cell 1.1"); var_Items.InsertItem(h,null,"Cell 1.2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("R2"); var_Items.InsertItem(h,null,"Cell 2.1"); var_Items.InsertItem(h,null,"Cell 2.2"); var_Items.set_ExpandItem(h,true); axGantt1.EndUpdate(); |
689 |
Is it possible to change the style for the vertical or horizontal grid lines, in the list area
axGantt1.BeginUpdate(); axGantt1.DrawGridLines = EXGANTTLib.GridLinesEnum.exAllLines; axGantt1.GridLineStyle = EXGANTTLib.GridLinesStyleEnum.exGridLinesVSolid | EXGANTTLib.GridLinesStyleEnum.exGridLinesHDot4; axGantt1.Columns.Add("C1"); axGantt1.Columns.Add("C2"); axGantt1.Columns.Add("C3"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Item 1"); var_Items.set_CellCaption(h,1,"SubItem 1.2"); var_Items.set_CellCaption(h,2,"SubItem 1.3"); h = var_Items.AddItem("Item 2"); var_Items.set_CellCaption(h,1,"SubItem 2.2"); var_Items.set_CellCaption(h,2,"SubItem 2.3"); axGantt1.EndUpdate(); |
688 |
How can I show the bars over the grid lines, i.e. so you cannot see the grid lines 'through' the bar
axGantt1.BeginUpdate(); axGantt1.DrawGridLines = EXGANTTLib.GridLinesEnum.exAllLines; axGantt1.GridLineColor = Color.FromArgb(220,220,220); EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.set_PaneWidth(false,48); var_Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); var_Chart.DrawGridLines = EXGANTTLib.GridLinesEnum.exAllLines; var_Chart.GridLineStyle = EXGANTTLib.GridLinesStyleEnum.exGridLinesBehind; var_Chart.LevelCount = 2; EXGANTTLib.Level var_Level = var_Chart.get_Level(1); var_Level.DrawGridLines = true; var_Level.GridLineColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(220,220,220)); EXGANTTLib.Bar var_Bar = var_Chart.Bars["Task"]; var_Bar.Pattern = EXGANTTLib.PatternEnum.exPatternSolid; var_Bar.Height = 14; axGantt1.Columns.Add("Column"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Item 1"); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/5/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"A",null); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/8/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/15/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"B",null); axGantt1.EndUpdate(); |
687 |
Is it possible to change the style for the vertical grid lines, in the chart area only
axGantt1.BeginUpdate(); axGantt1.DrawGridLines = EXGANTTLib.GridLinesEnum.exAllLines; axGantt1.GridLineStyle = EXGANTTLib.GridLinesStyleEnum.exGridLinesDash; EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.set_PaneWidth(false,48); var_Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); var_Chart.DrawGridLines = EXGANTTLib.GridLinesEnum.exAllLines; var_Chart.GridLineStyle = EXGANTTLib.GridLinesStyleEnum.exGridLinesDash; var_Chart.LevelCount = 2; var_Chart.get_Level(1).DrawGridLines = true; EXGANTTLib.Level var_Level = var_Chart.get_Level(0); var_Level.GridLineColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0)); var_Level.GridLineStyle = EXGANTTLib.GridLinesStyleEnum.exGridLinesVSolid; var_Chart.Bars["Task"].Pattern = EXGANTTLib.PatternEnum.exPatternSolid; axGantt1.Columns.Add("Column"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Item 1"); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/5/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"A",null); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/8/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/15/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"B",null); axGantt1.EndUpdate(); |
686 |
Is it possible to change the style for the grid lines, for instance to be solid not dotted
axGantt1.BeginUpdate(); axGantt1.DrawGridLines = EXGANTTLib.GridLinesEnum.exAllLines; axGantt1.GridLineStyle = EXGANTTLib.GridLinesStyleEnum.exGridLinesSolid; EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.set_PaneWidth(false,48); var_Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); var_Chart.DrawGridLines = EXGANTTLib.GridLinesEnum.exAllLines; var_Chart.GridLineStyle = EXGANTTLib.GridLinesStyleEnum.exGridLinesSolid; var_Chart.LevelCount = 2; var_Chart.get_Level(1).DrawGridLines = true; var_Chart.Bars["Task"].Pattern = EXGANTTLib.PatternEnum.exPatternSolid; axGantt1.Columns.Add("Column"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Item 1"); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/5/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"A",null); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/8/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/15/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"B",null); axGantt1.EndUpdate(); |
685 |
How can I show the grid lines for the chart and list area
axGantt1.DrawGridLines = EXGANTTLib.GridLinesEnum.exAllLines; EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.set_PaneWidth(false,48); var_Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); var_Chart.DrawGridLines = EXGANTTLib.GridLinesEnum.exAllLines; var_Chart.LevelCount = 2; var_Chart.get_Level(1).DrawGridLines = true; var_Chart.Bars["Task"].Pattern = EXGANTTLib.PatternEnum.exPatternSolid; axGantt1.Columns.Add("Column"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Item 1"); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/5/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"A",null); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/8/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/15/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"B",null); |
684 |
How can I get the link from the point
// MouseMove event - Occurs when the user moves the mouse. private void axGantt1_MouseMoveEvent(object sender, AxEXGANTTLib._IGanttEvents_MouseMoveEvent e) { System.Diagnostics.Debug.Print( axGantt1.Chart.get_LinkFromPoint(-1,-1).ToString() ); } //this.axGantt1.MouseMoveEvent += new AxEXGANTTLib._IGanttEvents_MouseMoveEventHandler(this.axGantt1_MouseMoveEvent); axGantt1.BeginUpdate(); axGantt1.Columns.Add("Task"); EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.FirstVisibleDate = Convert.ToDateTime("12/29/2000",System.Globalization.CultureInfo.GetCultureInfo("en-US")); var_Chart.set_PaneWidth(false,64); var_Chart.LevelCount = 2; EXGANTTLib.Items var_Items = axGantt1.Items; int h1 = var_Items.AddItem("Task 1"); var_Items.AddBar(h1,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); int h2 = var_Items.AddItem("Task 2"); var_Items.AddBar(h2,"Task",Convert.ToDateTime("1/5/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/7/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K2",null); var_Items.AddLink("L1",h1,"K1",h2,"K2"); var_Items.set_Link("L1",EXGANTTLib.LinkPropertyEnum.exLinkText,"L1"); int h3 = var_Items.AddItem("Task 3"); var_Items.AddBar(h3,"Task",Convert.ToDateTime("1/8/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/10/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K3",null); var_Items.AddLink("L2",h2,"K2",h3,"K3"); var_Items.set_Link("L2",EXGANTTLib.LinkPropertyEnum.exLinkText,"L2"); axGantt1.EndUpdate(); |
683 |
How can I get the bar from the point
// MouseMove event - Occurs when the user moves the mouse. private void axGantt1_MouseMoveEvent(object sender, AxEXGANTTLib._IGanttEvents_MouseMoveEvent e) { System.Diagnostics.Debug.Print( axGantt1.Chart.get_BarFromPoint(-1,-1).ToString() ); } //this.axGantt1.MouseMoveEvent += new AxEXGANTTLib._IGanttEvents_MouseMoveEventHandler(this.axGantt1_MouseMoveEvent); axGantt1.BeginUpdate(); axGantt1.Columns.Add("Task"); EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.FirstVisibleDate = Convert.ToDateTime("12/29/2000",System.Globalization.CultureInfo.GetCultureInfo("en-US")); var_Chart.set_PaneWidth(false,64); var_Chart.LevelCount = 2; EXGANTTLib.Items var_Items = axGantt1.Items; int h1 = var_Items.AddItem("Task 1"); var_Items.AddBar(h1,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); int h2 = var_Items.AddItem("Task 2"); var_Items.AddBar(h2,"Task",Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/6/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K2",null); var_Items.AddLink("L1",h1,"K1",h2,"K2"); int h3 = var_Items.AddItem("Task 3"); var_Items.AddBar(h3,"Task",Convert.ToDateTime("1/8/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/10/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K3",null); var_Items.AddLink("L2",h2,"K2",h3,"K3"); axGantt1.EndUpdate(); |
682 |
How can I get the level from the cursor
// MouseMove event - Occurs when the user moves the mouse. private void axGantt1_MouseMoveEvent(object sender, AxEXGANTTLib._IGanttEvents_MouseMoveEvent e) { System.Diagnostics.Debug.Print( axGantt1.Chart.get_LevelFromPoint(-1,-1).ToString() ); } //this.axGantt1.MouseMoveEvent += new AxEXGANTTLib._IGanttEvents_MouseMoveEventHandler(this.axGantt1_MouseMoveEvent); EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.FirstVisibleDate = Convert.ToDateTime("6/25/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")); var_Chart.set_PaneWidth(false,0); var_Chart.LevelCount = 4; |
681 |
I display numbers in my chart, but the AddBar requires a date how can I add a bar
axGantt1.BeginUpdate(); axGantt1.Columns.Add("Tasks"); EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.set_PaneWidth(false,0); var_Chart.NonworkingDays = 0; var_Chart.FirstVisibleDate = 0; var_Chart.ToolTip = ""; EXGANTTLib.Level var_Level = var_Chart.get_Level(0); var_Level.Label = "<%i%>"; var_Level.ToolTip = ""; var_Chart.UnitWidth = 24; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",2,4,null,null); var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",6,10,null,null); axGantt1.EndUpdate(); |
680 |
I display numbers in the chart's header but do not want to get displayed negative numbers. How can i do that
// DateChange event - Occurs when the first visible date is changed. private void axGantt1_DateChange(object sender, EventArgs e) { axGantt1.Chart.FirstVisibleDate = 0; axGantt1.set_ScrollPartEnable(EXGANTTLib.ScrollBarEnum.exHChartScroll,EXGANTTLib.ScrollPartEnum.exLeftBPart,false); } //this.axGantt1.DateChange += new EventHandler(this.axGantt1_DateChange); axGantt1.BeginUpdate(); EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.set_PaneWidth(false,0); var_Chart.NonworkingDays = 0; var_Chart.FirstVisibleDate = 0; var_Chart.ToolTip = ""; EXGANTTLib.Level var_Level = var_Chart.get_Level(0); var_Level.Label = "<%i%>"; var_Level.ToolTip = "<%i%>"; var_Chart.UnitWidth = 24; axGantt1.EndUpdate(); |
679 |
How can I display numbers in the chart's header instead dates
axGantt1.BeginUpdate(); EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.set_PaneWidth(false,0); var_Chart.NonworkingDays = 0; var_Chart.FirstVisibleDate = 0; var_Chart.ToolTip = ""; EXGANTTLib.Level var_Level = var_Chart.get_Level(0); var_Level.Label = "<%i%>"; var_Level.ToolTip = ""; var_Chart.UnitWidth = 24; axGantt1.EndUpdate(); |
678 |
How can I determine that a certain bar is the topmost
axGantt1.Columns.Add("Task"); EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.set_PaneWidth(false,48); var_Chart.FirstVisibleDate = Convert.ToDateTime("12/27/2000",System.Globalization.CultureInfo.GetCultureInfo("en-US")); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Bars A B"); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/6/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"A",null); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/6/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"B",null); var_Items.set_ItemBar(h,"B",EXGANTTLib.ItemBarPropertyEnum.exBarColor,255); h = var_Items.AddItem("Bars B A"); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/6/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"B",null); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/6/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"A",null); var_Items.set_ItemBar(h,"A",EXGANTTLib.ItemBarPropertyEnum.exBarColor,255); |
677 |
Is there any automatic way to change a property for all bars in the chart
axGantt1.Columns.Add("Task"); axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K2",null); var_Items.AddBar(var_Items.AddItem("Task 3"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K3",null); var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K4",null); var_Items.set_ItemBar(0,"<*>",EXGANTTLib.ItemBarPropertyEnum.exBarColor,255); |
676 |
I have an EBN file how can I apply different colors to it, so no need to create a new one
axGantt1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); axGantt1.SelBackColor = axGantt1.BackColor; axGantt1.SelForeColor = axGantt1.ForeColor; axGantt1.HasLines = EXGANTTLib.HierarchyLineEnum.exNoLine; axGantt1.Columns.Add("Default"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); int hC = var_Items.InsertItem(h,null,"Default"); var_Items.set_ItemBackColor(hC,0x1000000); var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6); hC = var_Items.InsertItem(h,null,"Light Green"); var_Items.set_ItemBackColor(hC,0x100ff00); var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6); hC = var_Items.InsertItem(h,null,"Dark Green"); var_Items.set_ItemBackColor(hC,0x1007f00); var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6); hC = var_Items.InsertItem(h,null,"Magenta"); var_Items.set_ItemBackColor(hC,0x1ff7fff); var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6); hC = var_Items.InsertItem(h,null,"Yellow"); var_Items.set_ItemBackColor(hC,0x17fffff); var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6); var_Items.set_ExpandItem(h,true); |
675 |
How can I remove all bars from the chart
axGantt1.Columns.Add("Task"); axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 3"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K2",null); var_Items.ClearBars(0); |
674 |
How can I change the color for all bars with a specified key
axGantt1.Columns.Add("Task"); axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 3"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K2",null); var_Items.set_ItemBar(0,"K1",EXGANTTLib.ItemBarPropertyEnum.exBarColor,255); |
673 |
Is there any automatic way to change a property for all bars with a specified key
axGantt1.Columns.Add("Task"); axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 3"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K2",null); var_Items.set_ItemBar(0,"K1",EXGANTTLib.ItemBarPropertyEnum.exBarColor,255); |
672 |
How can I remove all bars with specified key
axGantt1.Columns.Add("Task"); axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 3"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K2",null); var_Items.RemoveBar(0,"K1"); |
671 |
Is there any option to show gradient bars without using EBN technology
axGantt1.Columns.Add("Task"); axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); EXGANTTLib.Bar var_Bar = axGantt1.Chart.Bars["Task"]; var_Bar.Color = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0)); var_Bar.StartColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(0,255,0)); var_Bar.EndColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,255,0)); var_Bar.Pattern = EXGANTTLib.PatternEnum.exPatternBox; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Task"); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/5/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"",null); |
670 |
How can I disable the control's splitter so the user can't resize the list area
|
669 |
How can I disable the control's splitter so the user can't resize the chart area
|
668 |
How can I define a bar that shows two colors, one up and one down, without using skin or EBN files
axGantt1.BeginUpdate(); axGantt1.Columns.Add("Task"); axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); EXGANTTLib.Bar var_Bar = axGantt1.Chart.Bars.Add("A"); var_Bar.Color = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0)); var_Bar.Shape = EXGANTTLib.ShapeBarEnum.exShapeSolidUp; var_Bar.Pattern = EXGANTTLib.PatternEnum.exPatternSolid; EXGANTTLib.Bar var_Bar1 = axGantt1.Chart.Bars.Add("B"); var_Bar1.Color = (uint)ColorTranslator.ToWin32(Color.FromArgb(128,0,0)); var_Bar1.Shape = EXGANTTLib.ShapeBarEnum.exShapeSolidDown; var_Bar1.Pattern = EXGANTTLib.PatternEnum.exPatternSolid; axGantt1.Chart.Bars.Add("A%B").Shortcut = "AB"; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Task 1"); var_Items.AddBar(h,"AB",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/6/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.set_ItemBar(h,"K1",EXGANTTLib.ItemBarPropertyEnum.exBarPercent,1); axGantt1.EndUpdate(); |
667 |
Does your control support RightToLeft property for RTL languages or right to left
axGantt1.BeginUpdate(); axGantt1.ScrollBars = EXGANTTLib.ScrollBarsEnum.exDisableBoth; axGantt1.LinesAtRoot = EXGANTTLib.LinesAtRootEnum.exLinesAtRoot; EXGANTTLib.Column var_Column = (axGantt1.Columns.Add("P1") as EXGANTTLib.Column); var_Column.set_Def(EXGANTTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.PartialCheck = true; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.set_ExpandItem(h,true); axGantt1.RightToLeft = true; axGantt1.EndUpdate(); |
666 |
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
|
665 |
Can I display the cell's check box after the text
EXGANTTLib.Column var_Column = (axGantt1.Columns.Add("Column") as EXGANTTLib.Column); var_Column.set_Def(EXGANTTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.set_Def(EXGANTTLib.DefColumnEnum.exCellDrawPartsOrder,"caption,check"); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.set_CellHasCheckBox(var_Items.AddItem("Caption 1"),0,true); var_Items.set_CellHasCheckBox(var_Items.AddItem("Caption 2"),0,true); |
664 |
Can I change the order of the parts in the cell, as checkbox after the text, and so on
axGantt1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); (axGantt1.Columns.Add("Column") as EXGANTTLib.Column).set_Def(EXGANTTLib.DefColumnEnum.exCellDrawPartsOrder,"caption,check,icon,icons,picture"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Text"); var_Items.set_CellImage(h,0,1); var_Items.set_CellHasCheckBox(h,0,true); |
663 |
Can I have an image displayed after the text. Can I get that effect without using HTML content
axGantt1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); (axGantt1.Columns.Add("Column") as EXGANTTLib.Column).set_Def(EXGANTTLib.DefColumnEnum.exCellDrawPartsOrder,"caption,icon,check,icons,picture"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Text"); var_Items.set_CellImage(h,0,1); |
662 |
Is there any option to print the columns section on each page
axGantt1.BeginUpdate(); axGantt1.Columns.Add("Col 1"); axGantt1.Columns.Add("Col 2"); axGantt1.MarkSearchColumn = false; axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); axGantt1.Chart.LevelCount = 2; EXGANTTLib.Items var_Items = axGantt1.Items; int h1 = var_Items.AddItem("Col 1"); var_Items.set_CellCaption(h1,1,"Col 2"); var_Items.AddBar(h1,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); int h2 = var_Items.AddItem("Col 1"); var_Items.set_CellCaption(h2,1,"Col 2"); var_Items.AddBar(h2,"Task",Convert.ToDateTime("2/5/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("2/7/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K2",null); var_Items.AddLink("L1",h1,"K1",h2,"K2"); var_Items.set_Link("L1",EXGANTTLib.LinkPropertyEnum.exLinkStartPos,0); axGantt1.EndUpdate(); // Add 'ExPrint 1.0 Control Library(ExPrint.dll)' reference to your project. EXPRINTLib.Print var_Print = new EXPRINTLib.Print(); var_Print.Options = "ColumnsOnEveryPage=-2"; var_Print.PrintExt = (axGantt1.GetOcx() as EXGANTTLib.Gantt); var_Print.Preview(); |
661 |
Is there any option to print the columns section on each page
axGantt1.BeginUpdate(); axGantt1.Columns.Add("Task"); axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); axGantt1.Chart.LevelCount = 2; EXGANTTLib.Items var_Items = axGantt1.Items; int h1 = var_Items.AddItem("Task 1"); var_Items.AddBar(h1,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); int h2 = var_Items.AddItem("Task 2"); var_Items.AddBar(h2,"Task",Convert.ToDateTime("2/5/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("2/7/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K2",null); var_Items.AddLink("L1",h1,"K1",h2,"K2"); var_Items.set_Link("L1",EXGANTTLib.LinkPropertyEnum.exLinkStartPos,0); axGantt1.EndUpdate(); // Add 'ExPrint 1.0 Control Library(ExPrint.dll)' reference to your project. EXPRINTLib.Print var_Print = new EXPRINTLib.Print(); var_Print.Options = "ColumnsOnEveryPage=1"; var_Print.PrintExt = (axGantt1.GetOcx() as EXGANTTLib.Gantt); var_Print.Preview(); |
660 |
How do I print the control's content
axGantt1.BeginUpdate(); axGantt1.Columns.Add("Task"); axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); EXGANTTLib.Items var_Items = axGantt1.Items; int h1 = var_Items.AddItem("Task 1"); var_Items.AddBar(h1,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); int h2 = var_Items.AddItem("Task 2"); var_Items.AddBar(h2,"Task",Convert.ToDateTime("1/5/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/7/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K2",null); var_Items.AddLink("L1",h1,"K1",h2,"K2"); var_Items.set_Link("L1",EXGANTTLib.LinkPropertyEnum.exLinkStartPos,0); axGantt1.EndUpdate(); // Add 'ExPrint 1.0 Control Library(ExPrint.dll)' reference to your project. EXPRINTLib.Print var_Print = new EXPRINTLib.Print(); var_Print.PrintExt = (axGantt1.GetOcx() as EXGANTTLib.Gantt); var_Print.Preview(); |
659 |
How can I display the column using currency format and enlarge the font for certain values
EXGANTTLib.Column var_Column = (axGantt1.Columns.Add("Currency") as EXGANTTLib.Column); var_Column.set_Def(EXGANTTLib.DefColumnEnum.exCellCaptionFormat,1); var_Column.FormatColumn = "len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem("1.23"); var_Items.AddItem("2.34"); var_Items.AddItem("9.94"); var_Items.AddItem("11.94"); var_Items.AddItem("1000"); |
658 |
How can I highlight only parts of the cells
EXGANTTLib.Column var_Column = (axGantt1.Columns.Add("") as EXGANTTLib.Column); var_Column.set_Def(EXGANTTLib.DefColumnEnum.exCellCaptionFormat,1); var_Column.FormatColumn = "value replace 'hil' with '<fgcolor=FF0000><b>hil</b></fgcolor>'"; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.InsertItem(h,null,"Child 3"); var_Items.set_ExpandItem(h,true); |
657 |
How can I get the number of occurrences of a specified string in the cell
axGantt1.Columns.Add(""); EXGANTTLib.Column var_Column = (axGantt1.Columns.Add("occurrences") as EXGANTTLib.Column); var_Column.ComputedField = "lower(%0) count 'o'"; var_Column.FormatColumn = "'contains ' + value + ' of \\'o\\' chars'"; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1 oooof the root"); var_Items.InsertItem(h,null,"Child 2"); var_Items.InsertItem(h,null,"Child 3"); var_Items.set_ExpandItem(h,true); |
656 |
How can I display dates in my format
EXGANTTLib.Column var_Column = (axGantt1.Columns.Add("Date") as EXGANTTLib.Column); var_Column.set_Def(EXGANTTLib.DefColumnEnum.exCellCaptionFormat,1); var_Column.FormatColumn = "'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/21/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/22/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/24/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
655 |
How can I display dates in short format
(axGantt1.Columns.Add("Date") as EXGANTTLib.Column).FormatColumn = "shortdate(value)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/2/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/3/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/4/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
654 |
How can I display dates in long format
(axGantt1.Columns.Add("Date") as EXGANTTLib.Column).FormatColumn = "longdate(value)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/2/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/3/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/4/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
653 |
How can I display only the right part of the cell
axGantt1.Columns.Add(""); EXGANTTLib.Column var_Column = (axGantt1.Columns.Add("Right") as EXGANTTLib.Column); var_Column.ComputedField = "%0 right 2"; var_Column.FormatColumn = "'\"' + value + '\"'"; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.InsertItem(h,null,"SChild 3"); var_Items.set_ExpandItem(h,true); |
652 |
How can I display only the left part of the cell
axGantt1.Columns.Add(""); (axGantt1.Columns.Add("Left") as EXGANTTLib.Column).ComputedField = "%0 left 2"; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.InsertItem(h,null,"SChild 3"); var_Items.set_ExpandItem(h,true); |
651 |
How can I display true or false instead 0 and -1
(axGantt1.Columns.Add("Boolean") as EXGANTTLib.Column).FormatColumn = "value != 0 ? 'true' : 'false'"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(true); var_Items.AddItem(false); var_Items.AddItem(true); var_Items.AddItem(0); var_Items.AddItem(1); |
650 |
How can I display icons or images instead numbers
axGantt1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXGANTTLib.Column var_Column = (axGantt1.Columns.Add("Icons") as EXGANTTLib.Column); var_Column.set_Def(EXGANTTLib.DefColumnEnum.exCellCaptionFormat,1); var_Column.FormatColumn = "'The cell displays the icon <img>'+value+'</img> instead ' + value"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(1); var_Items.AddItem(2); var_Items.AddItem(3); |
649 |
How can I display the column using currency
(axGantt1.Columns.Add("Currency") as EXGANTTLib.Column).FormatColumn = "currency(dbl(value))"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem("1.23"); var_Items.AddItem("2.34"); var_Items.AddItem("0"); var_Items.AddItem(5); var_Items.AddItem("10000.99"); |
648 |
How can I display the currency only for not empty cells
axGantt1.Columns.Add("Number"); (axGantt1.Columns.Add("Currency") as EXGANTTLib.Column).ComputedField = "len(%0) ? currency(dbl(%0)) : ''"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem("1.23"); var_Items.AddItem("2.34"); var_Items.AddItem("0"); var_Items.set_ItemBackColor(var_Items.AddItem(null),(uint)ColorTranslator.ToWin32(Color.FromArgb(255,128,128))); var_Items.AddItem("10000.99"); |
647 |
Is there a function to display the number of days between two date including the number of hours
(axGantt1.Columns.Add("Start") as EXGANTTLib.Column).Width = 32; axGantt1.Columns.Add("End"); (axGantt1.Columns.Add("Duration") as EXGANTTLib.Column).ComputedField = "2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '' : str(=:1) + ' day(s)') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? ' and ' : " + "'') + =:3 + ' hour(s)' : '' )"; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); h = var_Items.AddItem(Convert.ToDateTime("2/22/2002 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
646 |
Is there a function to display the number of days between two date including the number of hours
axGantt1.Columns.Add("Start"); axGantt1.Columns.Add("End"); (axGantt1.Columns.Add("Duration") as EXGANTTLib.Column).ComputedField = "\"D \" + int(date(%1)-date(%0)) + \" H \" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))"; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001 23:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); h = var_Items.AddItem(Convert.ToDateTime("2/22/2002 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
645 |
How can I display the number of days between two dates
axGantt1.Columns.Add("Start"); axGantt1.Columns.Add("End"); (axGantt1.Columns.Add("Duration") as EXGANTTLib.Column).ComputedField = "(date(%1)-date(%0)) + ' days'"; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); h = var_Items.AddItem(Convert.ToDateTime("2/22/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
644 |
How can I get second part of the date
axGantt1.Columns.Add("Date"); (axGantt1.Columns.Add("Second") as EXGANTTLib.Column).ComputedField = "sec(date(%0))"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:10:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:01:22",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:23:01",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:11:59",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
643 |
How can I get minute part of the date
axGantt1.Columns.Add("Date"); (axGantt1.Columns.Add("Minute") as EXGANTTLib.Column).ComputedField = "min(date(%0))"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:10:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:01:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:23:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:11:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
642 |
How can I check the hour part only so I know it was afternoon
axGantt1.ConditionalFormats.Add("hour(%0)>=12",null).Bold = true; axGantt1.Columns.Add("Date"); (axGantt1.Columns.Add("Hour") as EXGANTTLib.Column).ComputedField = "hour(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
641 |
What about a function to get the day in the week, or days since Sunday
axGantt1.Columns.Add("Date"); (axGantt1.Columns.Add("WeekDay") as EXGANTTLib.Column).ComputedField = "weekday(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
640 |
Is there any function to get the day of the year or number of days since January 1st
axGantt1.Columns.Add("Date"); (axGantt1.Columns.Add("Day since January 1st") as EXGANTTLib.Column).ComputedField = "yearday(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
639 |
How can I display only the day of the date
axGantt1.Columns.Add("Date"); (axGantt1.Columns.Add("Day") as EXGANTTLib.Column).ComputedField = "day(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
638 |
How can I display only the month of the date
axGantt1.Columns.Add("Date"); (axGantt1.Columns.Add("Month") as EXGANTTLib.Column).ComputedField = "month(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/4/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
637 |
How can I get only the year part from a date expression
axGantt1.Columns.Add("Date"); (axGantt1.Columns.Add("Year") as EXGANTTLib.Column).ComputedField = "year(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/4/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
636 |
Can I convert the expression to date
axGantt1.Columns.Add("Number"); (axGantt1.Columns.Add("Date") as EXGANTTLib.Column).ComputedField = "date(dbl(%0))"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("30000.99"); var_Items.AddItem("3561.23"); var_Items.AddItem("1232.34"); |
635 |
Can I convert the expression to a number, double or float
axGantt1.Columns.Add("Number"); (axGantt1.Columns.Add("Number + 2") as EXGANTTLib.Column).ComputedField = "dbl(%0)+2"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("0.99"); var_Items.AddItem("1.23"); var_Items.AddItem("2.34"); |
634 |
How can I display dates in long format
axGantt1.Columns.Add("Date"); (axGantt1.Columns.Add("LongFormat") as EXGANTTLib.Column).ComputedField = "longdate(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/4/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
633 |
How can I display dates in short format
axGantt1.Columns.Add("Date"); (axGantt1.Columns.Add("ShortFormat") as EXGANTTLib.Column).ComputedField = "shortdate(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/4/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
632 |
How can I display the time only of a date expression
axGantt1.Columns.Add("Date"); (axGantt1.Columns.Add("Time") as EXGANTTLib.Column).ComputedField = "'time is:' + time(date(%0))"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); var_Items.AddItem(Convert.ToDateTime("4/4/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US"))); |
631 |
Is there any function to display currencies, or money formatted as in the control panel
axGantt1.Columns.Add("Number"); (axGantt1.Columns.Add("Currency") as EXGANTTLib.Column).ComputedField = "currency(dbl(%0))"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem("1.23"); var_Items.AddItem("2.34"); var_Items.AddItem("10000.99"); |
630 |
How can I convert the expression to a string so I can look into the date string expression for month's name
axGantt1.Columns.Add("Number"); (axGantt1.Columns.Add("Str") as EXGANTTLib.Column).ComputedField = "str(%0) + ' AA'"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("0.99"); var_Items.AddItem("1.23"); var_Items.AddItem("2.34"); |
629 |
Can I display the absolute value or positive part of the number
axGantt1.Columns.Add("Number"); (axGantt1.Columns.Add("Abs") as EXGANTTLib.Column).ComputedField = "abs(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("0.99"); var_Items.AddItem("1.23"); var_Items.AddItem("2.34"); |
628 |
Is there any function to get largest number with no fraction part that is not greater than the value
axGantt1.Columns.Add("Number"); (axGantt1.Columns.Add("Floor") as EXGANTTLib.Column).ComputedField = "floor(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("0.99"); var_Items.AddItem("1.23"); var_Items.AddItem("2.34"); |
627 |
Is there any function to round the values base on the .5 value
axGantt1.Columns.Add("Number"); (axGantt1.Columns.Add("Round") as EXGANTTLib.Column).ComputedField = "round(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("0.99"); var_Items.AddItem("1.23"); var_Items.AddItem("2.34"); |
626 |
How can I get or display the integer part of the cell
axGantt1.Columns.Add("Number"); (axGantt1.Columns.Add("Int") as EXGANTTLib.Column).ComputedField = "int(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("0.99"); var_Items.AddItem("1.23"); var_Items.AddItem("2.34"); |
625 |
How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
(axGantt1.Columns.Add("") as EXGANTTLib.Column).ComputedField = "proper(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("root"); var_Items.InsertItem(h,null,"child child"); var_Items.InsertItem(h,null,"child child"); var_Items.InsertItem(h,null,"child child"); var_Items.set_ExpandItem(h,true); |
624 |
Is there any option to display cells in uppercase
(axGantt1.Columns.Add("") as EXGANTTLib.Column).ComputedField = "upper(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.InsertItem(h,null,"Chld 3"); var_Items.set_ExpandItem(h,true); |
623 |
Is there any option to display cells in lowercase
(axGantt1.Columns.Add("") as EXGANTTLib.Column).ComputedField = "lower(%0)"; EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.InsertItem(h,null,"Chld 3"); var_Items.set_ExpandItem(h,true); |
622 |
How can I mark the cells that has a specified type, ie strings only
|
621 |
How can I bold the items that contains data or those who displays empty strings
axGantt1.ConditionalFormats.Add("not len(%1)=0",null).Bold = true; axGantt1.Columns.Add("C1"); axGantt1.Columns.Add("C2"); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); int hC = var_Items.InsertItem(h,null,"Child 2"); var_Items.set_CellCaption(hC,1,"1"); var_Items.InsertItem(h,null,"Child 3"); var_Items.set_ExpandItem(h,true); |
620 |
Can I change the background color for items or cells that contains a specified string
axGantt1.ConditionalFormats.Add("%0 contains 'hi'",null).BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0)); axGantt1.Columns.Add(""); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.InsertItem(h,null,"Chld 3"); var_Items.set_ExpandItem(h,true); |
619 |
Is there any option to change the fore color for cells or items that ends with a specified string
axGantt1.ConditionalFormats.Add("%0 endwith '22'",null).ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0)); axGantt1.Columns.Add(""); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 1.22"); var_Items.InsertItem(h,null,"Child 2.22"); var_Items.set_ExpandItem(h,true); |
618 |
How can I highlight the cells or items that starts with a specified string
axGantt1.ConditionalFormats.Add("%0 startwith 'C'",null).Underline = true; axGantt1.Columns.Add(""); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,null,"Child 1"); var_Items.InsertItem(h,null,"Child 2"); var_Items.InsertItem(h,null,"SChild 3"); var_Items.set_ExpandItem(h,true); |
617 |
How can I change the background color or the visual appearance using ebn for a particular column
axGantt1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); EXGANTTLib.Columns var_Columns = axGantt1.Columns; var_Columns.Add("Column 1"); (var_Columns.Add("Column 2") as EXGANTTLib.Column).set_Def(EXGANTTLib.DefColumnEnum.exHeaderBackColor,16777216); (var_Columns.Add("Column 3") as EXGANTTLib.Column).set_Def(EXGANTTLib.DefColumnEnum.exHeaderBackColor,16777471); var_Columns.Add("Column 4"); |
616 |
How can I change the background color for a particular column
|
615 |
Is it possible to define level in terms of just increasing numbers (not a Date)
|
614 |
How can I hide the non-working units ( days or hours )
|
613 |
Is there a way to have the display show the word "Noon" instead "12:00 PM" in the chart's header/levels
|
612 |
How can I change the selection background color in the chart area
axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); axGantt1.Chart.SelBackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0)); axGantt1.Columns.Add("Column"); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Item 1"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),null,null); var_Items.AddBar(var_Items.AddItem("Item 1"),"Task",Convert.ToDateTime("1/6/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),null,null); var_Items.set_SelectItem(var_Items.FirstVisibleItem,true); |
611 |
How can I change the selection background color in the chart area
axGantt1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); axGantt1.Chart.SelBackColor = 0x1000000; axGantt1.Columns.Add("Column"); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Item 1"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),null,null); var_Items.AddBar(var_Items.AddItem("Item 1"),"Task",Convert.ToDateTime("1/6/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),null,null); var_Items.set_SelectItem(var_Items.FirstVisibleItem,true); |
610 |
Is there any way to extend the selection on the chart
axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); axGantt1.Chart.SelBackColor = axGantt1.SelBackColor; axGantt1.Columns.Add("Column"); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Item 1"),"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/4/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),null,null); var_Items.AddBar(var_Items.AddItem("Item 1"),"Task",Convert.ToDateTime("1/6/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),null,null); var_Items.set_SelectItem(var_Items.FirstVisibleItem,true); |
609 |
How can I display the column's header using multiple lines
axGantt1.HeaderHeight = 128; axGantt1.HeaderSingleLine = false; (axGantt1.Columns.Add("This is just a column that should break the header.") as EXGANTTLib.Column).Width = 32; axGantt1.Columns.Add("This is just another column that should break the header."); |
608 |
How can change the width, transparency, style, visual appearance ( EBN), of the vertical bar that shows the current date-time
axGantt1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.LevelCount = 2; var_Chart.get_Level(0).Label = 1048576; EXGANTTLib.Level var_Level = var_Chart.get_Level(1); var_Level.Label = "<%ss%>"; var_Level.Count = 15; var_Chart.MarkNowColor = 0x1000000; var_Chart.MarkNowWidth = 6; var_Chart.MarkNowTransparent = 50; axGantt1.Columns.Add("Tasks"); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Item 1"),"Task",Convert.ToDateTime("1/1/2008",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/1/2018",System.Globalization.CultureInfo.GetCultureInfo("en-US")),null,null); |
607 |
How can change the width, style, visual appearance ( EBN), of the vertical bar that shows the current time
axGantt1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.LevelCount = 2; var_Chart.get_Level(0).Label = 1048576; EXGANTTLib.Level var_Level = var_Chart.get_Level(1); var_Level.Label = "<%ss%>"; var_Level.Count = 15; var_Chart.MarkNowColor = 0x1000000; var_Chart.MarkNowWidth = 6; axGantt1.Columns.Add("Tasks"); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Item 1"),"Task",Convert.ToDateTime("1/1/2008",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/1/2018",System.Globalization.CultureInfo.GetCultureInfo("en-US")),null,null); |
606 |
How can I show a vertical bar that indicates the current time
EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.LevelCount = 2; var_Chart.get_Level(0).Label = 1048576; EXGANTTLib.Level var_Level = var_Chart.get_Level(1); var_Level.Label = "<%ss%>"; var_Level.Count = 15; var_Chart.MarkNowColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,255)); var_Chart.MarkNowWidth = 7; axGantt1.Columns.Add("Tasks"); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Item 1"),"Task",Convert.ToDateTime("1/1/2008",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/1/2018",System.Globalization.CultureInfo.GetCultureInfo("en-US")),null,null); |
605 |
How can I show semi-transparent the vertical bar that indicates the current time
EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.LevelCount = 2; var_Chart.get_Level(0).Label = 1048576; EXGANTTLib.Level var_Level = var_Chart.get_Level(1); var_Level.Label = "<%ss%>"; var_Level.Count = 15; var_Chart.MarkNowColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,255)); var_Chart.MarkNowWidth = 7; var_Chart.MarkNowTransparent = 50; axGantt1.Columns.Add("Tasks"); EXGANTTLib.Items var_Items = axGantt1.Items; var_Items.AddBar(var_Items.AddItem("Item 1"),"Task",Convert.ToDateTime("1/1/2008",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/1/2018",System.Globalization.CultureInfo.GetCultureInfo("en-US")),null,null); |
604 |
Is there any way to highlight or show a vertical bar that indicates the current time, from 15 to 15 seconds
axGantt1.Chart.LevelCount = 2; axGantt1.Chart.get_Level(0).Label = 1048576; EXGANTTLib.Level var_Level = axGantt1.Chart.get_Level(1); var_Level.Label = "<%ss%>"; var_Level.Count = 15; axGantt1.Chart.MarkNowColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,255)); axGantt1.Chart.MarkNowCount = 15; axGantt1.Chart.MarkNowWidth = 3; |
603 |
Is there any way to highlight or show a vertical bar that indicates the current time, from minute to minute, hour and so on
EXGANTTLib.Chart var_Chart = axGantt1.Chart; var_Chart.UnitWidth = 48; var_Chart.LevelCount = 1; var_Chart.get_Level(0).Label = 1048576; var_Chart.MarkNowColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0)); var_Chart.MarkNowUnit = EXGANTTLib.UnitEnum.exMinute; var_Chart.MarkNowWidth = var_Chart.UnitWidth; |
602 |
Is there any way to highlight or show a vertical bar that indicates the current time
|
601 |
Is there a way of making a bar flash on the screen
axGantt1.Columns.Add("Task"); axGantt1.Chart.FirstVisibleDate = Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")); EXGANTTLib.Items var_Items = axGantt1.Items; int h = var_Items.AddItem("Flashy task"); var_Items.AddBar(h,"Task",Convert.ToDateTime("1/2/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),Convert.ToDateTime("1/6/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")),"K1",null); var_Items.set_ItemBar(h,"K1",EXGANTTLib.ItemBarPropertyEnum.exBarTransparent,80); |